<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1">
  <title id="eb20941">RESET</title>
  <body>
    <p id="sql_command_desc">Restores the value of a system configuration parameter to the default
      value.</p>
    <section id="section2">
      <title>Synopsis</title>
      <codeblock id="sql_command_synopsis">RESET <varname>configuration_parameter</varname>

RESET ALL</codeblock>
    </section>
    <section id="section3">
      <title>Description</title>
      <p><codeph>RESET</codeph> restores system configuration parameters to their default values.
          <codeph>RESET</codeph> is an alternative spelling for <codeph>SET
            <varname>configuration_parameter</varname> TO DEFAULT</codeph>.</p>
      <p>The default value is defined as the value that the parameter would have had, had no
          <codeph>SET</codeph> ever been issued for it in the current session. The actual source of
        this value might be a compiled-in default, the master <codeph>postgresql.conf</codeph>
        configuration file, command-line options, or per-database or per-user default settings. See
          <xref href="../config_params/guc_config.xml" type="topic" format="dita"/> for more information. </p>
    </section>
    <section id="section4">
      <title>Parameters</title>
      <parml>
        <plentry>
          <pt>
            <varname>configuration_parameter</varname>
          </pt>
          <pd>The name of a system configuration parameter. See <xref href="../config_params/guc_config.xml"
              type="topic" format="dita"/> for details. </pd>
        </plentry>
        <plentry>
          <pt>ALL</pt>
          <pd>Resets all settable configuration parameters to their default values. </pd>
        </plentry>
      </parml>
    </section>
    <section id="section5">
      <title>Examples</title>
      <p>Set the <codeph>statement_mem</codeph> configuration parameter to its default value:</p>
      <codeblock>RESET statement_mem; </codeblock>
    </section>
    <section id="section6">
      <title>Compatibility</title>
      <p><codeph>RESET</codeph> is a Greenplum Database extension.</p>
    </section>
    <section id="section7">
      <title>See Also</title>
      <p>
        <codeph>
          <xref href="./SET.xml#topic1" type="topic" format="dita"/>
        </codeph>
      </p>
    </section>
  </body>
</topic>
